2013-04-22 - 5738.400 - Spec - Mexico enhancements - Invoice Extract #Mexico #SDMiscellaneousReports #ABAPEXTRACT

SPECIFICATIONS

5738.400 - Spec - Mexico Enhancements

Purpose

---

To update the EDICOM extract both SD and FI to pull the payment method and bank account details from the customer master if they exist. If not, display the currently hard-coded message.

Admin Info

---

Purpose	Modify the EDICOM extract program both SD and FI to get the data of Payment method and Bank account details from the Customer.
Requested By	Daniel Brennan
Spec Created By	Krishna Sandeep
Spec Created Date	04/25/2013
Spec QA by	Deepak Yasam
Objects	Program: ZISD_ETI_INVOICE_EXTRACT ZIFI_ETI_INVOICE_EXTRACT
Document Status	Completed

References

---

Prior Tickets

None.

Documents

None.

Functional Requirement

---

Needs to change the logic in Mexico ETI extract program of both SD and FI for two fields Payment method and Account number.
We are fetching the Payment method description based on the value Payment method of an Invoice document instead have to change the logic of fetching payment method from Customer master data.
We are fetching the hard coded value maintained in TVARVC table for the field Account number and for this have to change logic to display the last 4 digits of customer bank account number, if Payment Method and Account number exists for a customer(Payer).

Solution Summary

---

[Discuss this section with Requester and get approval prior to beginning work]
Modify the program "ZISD_ETI_INVOICE_EXTRACT" to fetch the Payment method and Bank account details from the customer master if they exist, else display the currently hard-coded message.
Get the Payment method data based on the customer and company code maintained in the customer master.
Get the last 4 digits of Account number maintained in the customer master for Bank account details.

Test Plan

[List test scenarios/cases to be executed here]

Test Scenario	Expected Result
Add the payment method in the customer master (1010409) as Deposits 'D',bank account info and create a sales order with 1500,10.00 sales area and then delivery and invoice.Now execute the ZETI output.	An ETI file should generate with the payment method description field and the last 4 characters of the bank account number.
Remove the payment method in the customer master (1010409) and keep bank account info and create a sales order with 1500,10.00 sales area and then delivery and invoice.Now execute the ZETI output.	An ETI file shouldgenerate with the default 'No identificado'field and the bank account number should also get default with 'No identificado'.

Solution Details

---

[Provide complete technical details for configuration or programming here]
For the field Payment method description, get the data from KNB1 table based on Customer(Payer) & Company code and if it fails get the hard coded value which is maintained in TVARVC table.
For the field Account number, get the data from KNBK based on Customer number(Payer) and restrict the value from displaying it to last four digits only if the Account number and Payment method exist for that particular customer else display the hard coded value maintained in TVARVC table.

Issues

---

None.